Oracle Console

Oracle Console (SQL*Plus) allows you to use a command-line interface. In other words, it provides interactive text-based screen for you to query input and result output from database.

Note: You have to have SQL*Plus executable in order to get this works. If it is not set under the SQL*Plus default path, you are prompted to locate the executable in the pop up.

Downloading

SQL*Plus is included in packages Oracle Client / Oracle Instant Client. You can download it through -

Oracle Client
http://www.oracle.com/technology/software/products/database/index.html

Oracle Instant Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Open Console

To open console

Hint: To open a new console window you can also control-click the Connection/Schema node of the navigation pane and select SQL*Plus from the popup menu.

Hint: You are allowed to open multiple console windows which represents different connection each.

Exit Console

To exit console